<?php

use yii\db\Migration;

class m191009_090108_addon_shop_express_fee extends Migration
{
    public function up()
    {
        /* 取消外键约束 */
        $this->execute('SET foreign_key_checks = 0');
        
        /* 创建表 */
        $this->createTable('{{%addon_shop_express_fee}}', [
            'id' => "int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '运费模板ID'",
            'merchant_id' => "int(10) unsigned NULL DEFAULT '0' COMMENT '商户id'",
            'company_id' => "int(11) unsigned NOT NULL DEFAULT '0' COMMENT '物流公司ID'",
            'title' => "varchar(30) NOT NULL DEFAULT '' COMMENT '运费模板名称'",
            'is_default' => "tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '是否是默认模板'",
            'province_ids' => "text NULL COMMENT '省ID组'",
            'city_ids' => "text NULL COMMENT '市ID组'",
            'area_ids' => "text NULL COMMENT '区县ID组'",
            'weight_is_use' => "tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否启用重量运费'",
            'weight_snum' => "decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '首重'",
            'weight_sprice' => "decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '首重运费'",
            'weight_xnum' => "decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '续重'",
            'weight_xprice' => "decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '续重运费'",
            'volume_is_use' => "tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否启用体积计算运费'",
            'volume_snum' => "decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '首体积量'",
            'volume_sprice' => "decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '首体积运费'",
            'volume_xnum' => "decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '续体积量'",
            'volume_xprice' => "decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '续体积运费'",
            'bynum_is_use' => "tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否启用计件方式运费'",
            'bynum_snum' => "int(11) NOT NULL DEFAULT '0' COMMENT '首件'",
            'bynum_sprice' => "decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '首件运费'",
            'bynum_xnum' => "int(11) NOT NULL DEFAULT '0' COMMENT '续件'",
            'bynum_xprice' => "decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '续件运费'",
            'status' => "tinyint(4) NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]'",
            'created_at' => "int(10) unsigned NULL DEFAULT '0' COMMENT '创建时间'",
            'updated_at' => "int(10) unsigned NULL DEFAULT '0' COMMENT '更新时间'",
            'PRIMARY KEY (`id`)'
        ], "ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AVG_ROW_LENGTH=16384 ROW_FORMAT=DYNAMIC COMMENT='运费模板'");
        
        /* 索引设置 */
        
        
        /* 表数据 */
        $this->insert('{{%addon_shop_express_fee}}',['id'=>'1','merchant_id'=>'1','company_id'=>'1','title'=>'天天快递','is_default'=>'1','province_ids'=>'','city_ids'=>'','area_ids'=>'','weight_is_use'=>'1','weight_snum'=>'1.00','weight_sprice'=>'8.00','weight_xnum'=>'1.00','weight_xprice'=>'5.00','volume_is_use'=>'1','volume_snum'=>'10.00','volume_sprice'=>'30.00','volume_xnum'=>'2.00','volume_xprice'=>'6.00','bynum_is_use'=>'1','bynum_snum'=>'1','bynum_sprice'=>'10.00','bynum_xnum'=>'1','bynum_xprice'=>'8.00','status'=>'1','created_at'=>'1557394765','updated_at'=>'1558059737']);
        $this->insert('{{%addon_shop_express_fee}}',['id'=>'2','merchant_id'=>'1','company_id'=>'1','title'=>'华北区','is_default'=>'0','province_ids'=>'110000,120000,130000,140000,150000,370000','city_ids'=>'110100,120100,130100,130200,130300,130400,130500,130600,130700,130800,130900,131000,131100,140100,140200,140300,140400,140500,140600,140700,140800,140900,141000,141100,150100,150200,150300,150400,150500,150600,150700,150800,150900,152200,152500,152900,370100,370200,370300,370400,370500,370600,370700,370800,370900,371000,371100,371200,371300,371400,371500,371600,371700','area_ids'=>'110101,110102,110105,110106,110107,110108,110109,110111,110112,110113,110114,110115,110116,110117,110118,110119,120101,120102,120103,120104,120105,120106,120110,120111,120112,120113,120114,120115,120116,120117,120118,120119,130102,130104,130105,130107,130108,130109,130110,130111,130121,130123,130125,130126,130127,130128,130129,130130,130131,130132,130133,130171,130172,130181,130183,130184,130202,130203,130204,130205,130207,130208,130209,130223,130224,130225,130227,130229,130271,130272,130273,130274,130281,130283,130302,130303,130304,130306,130321,130322,130324,130371,130372,130402,130403,130404,130406,130407,130408,130423,130424,130425,130426,130427,130430,130431,130432,130433,130434,130435,130471,130473,130481,130502,130503,130521,130522,130523,130524,130525,130526,130527,130528,130529,130530,130531,130532,130533,130534,130535,130571,130581,130582,130602,130606,130607,130608,130609,130623,130624,130626,130627,130628,130629,130630,130631,130632,130633,130634,130635,130636,130637,130638,130671,130672,130681,130682,130683,130684,130702,130703,130705,130706,130708,130709,130722,130723,130724,130725,130726,130727,130728,130730,130731,130732,130771,130772,130773,130802,130803,130804,130821,130822,130824,130825,130826,130827,130828,130871,130881,130902,130903,130921,130922,130923,130924,130925,130926,130927,130928,130929,130930,130971,130972,130973,130981,130982,130983,130984,131002,131003,131022,131023,131024,131025,131026,131028,131071,131081,131082,131102,131103,131121,131122,131123,131124,131125,131126,131127,131128,131171,131172,131182,140105,140106,140107,140108,140109,140110,140121,140122,140123,140171,140181,140202,140203,140211,140212,140221,140222,140223,140224,140225,140226,140227,140271,140302,140303,140311,140321,140322,140371,140402,140411,140421,140423,140424,140425,140426,140427,140428,140429,140430,140431,140471,140481,140502,140521,140522,140524,140525,140581,140602,140603,140621,140622,140623,140624,140671,140702,140721,140722,140723,140724,140725,140726,140727,140728,140729,140781,140802,140821,140822,140823,140824,140825,140826,140827,140828,140829,140830,140881,140882,140902,140921,140922,140923,140924,140925,140926,140927,140928,140929,140930,140931,140932,140971,140981,141002,141021,141022,141023,141024,141025,141026,141027,141028,141029,141030,141031,141032,141033,141034,141081,141082,141102,141121,141122,141123,141124,141125,141126,141127,141128,141129,141130,141181,141182,150102,150103,150104,150105,150121,150122,150123,150124,150125,150171,150172,150202,150203,150204,150205,150206,150207,150221,150222,150223,150271,150302,150303,150304,150402,150403,150404,150421,150422,150423,150424,150425,150426,150428,150429,150430,150502,150521,150522,150523,150524,150525,150526,150571,150581,150602,150603,150621,150622,150623,150624,150625,150626,150627,150702,150703,150721,150722,150723,150724,150725,150726,150727,150781,150782,150783,150784,150785,150802,150821,150822,150823,150824,150825,150826,150902,150921,150922,150923,150924,150925,150926,150927,150928,150929,150981,152201,152202,152221,152222,152223,152224,152501,152502,152522,152523,152524,152525,152526,152527,152528,152529,152530,152531,152571,152921,152922,152923,152971,370102,370103,370104,370105,370112,370113,370114,370124,370125,370126,370171,370202,370203,370211,370212,370213,370214,370215,370271,370281,370283,370285,370302,370303,370304,370305,370306,370321,370322,370323,370402,370403,370404,370405,370406,370481,370502,370503,370505,370522,370523,370571,370572,370602,370611,370612,370613,370634,370671,370672,370681,370682,370683,370684,370685,370686,370687,370702,370703,370704,370705,370724,370725,370772,370781,370782,370783,370784,370785,370786,370811,370812,370826,370827,370828,370829,370830,370831,370832,370871,370881,370883,370902,370911,370921,370923,370982,370983,371002,371003,371071,371072,371073,371082,371083,371102,371103,371121,371122,371171,371172,371202,371203,371302,371311,371312,371321,371322,371323,371324,371325,371326,371327,371328,371329,371371,371372,371373,371402,371403,371422,371423,371424,371425,371426,371427,371428,371471,371472,371481,371482,371502,371521,371522,371523,371524,371525,371526,371581,371602,371603,371621,371622,371623,371625,371626,371702,371703,371721,371722,371723,371724,371725,371726,371728,371771,371772','weight_is_use'=>'1','weight_snum'=>'1.00','weight_sprice'=>'10.00','weight_xnum'=>'1.00','weight_xprice'=>'10.00','volume_is_use'=>'1','volume_snum'=>'10.00','volume_sprice'=>'10.00','volume_xnum'=>'10.00','volume_xprice'=>'10.00','bynum_is_use'=>'1','bynum_snum'=>'1','bynum_sprice'=>'10.00','bynum_xnum'=>'1','bynum_xprice'=>'10.00','status'=>'1','created_at'=>'1557804345','updated_at'=>'1558059791']);
        $this->insert('{{%addon_shop_express_fee}}',['id'=>'3','merchant_id'=>'1','company_id'=>'2','title'=>'北京地区','is_default'=>'0','province_ids'=>'110000','city_ids'=>'110100','area_ids'=>'110101,110102,110105,110106,110107,110108,110109,110111,110112,110113,110114,110115,110116,110117,110118,110119','weight_is_use'=>'1','weight_snum'=>'0.00','weight_sprice'=>'0.00','weight_xnum'=>'0.00','weight_xprice'=>'0.00','volume_is_use'=>'1','volume_snum'=>'0.00','volume_sprice'=>'0.00','volume_xnum'=>'0.00','volume_xprice'=>'0.00','bynum_is_use'=>'1','bynum_snum'=>'0','bynum_sprice'=>'0.00','bynum_xnum'=>'0','bynum_xprice'=>'0.00','status'=>'1','created_at'=>'1558509638','updated_at'=>'1558509638']);
        $this->insert('{{%addon_shop_express_fee}}',['id'=>'4','merchant_id'=>'1','company_id'=>'2','title'=>'1312','is_default'=>'0','province_ids'=>'350000,440000,450000','city_ids'=>'350100,440300,450300','area_ids'=>'350112,440311,450381','weight_is_use'=>'1','weight_snum'=>'0.00','weight_sprice'=>'0.00','weight_xnum'=>'0.00','weight_xprice'=>'0.00','volume_is_use'=>'1','volume_snum'=>'0.00','volume_sprice'=>'0.00','volume_xnum'=>'0.00','volume_xprice'=>'0.00','bynum_is_use'=>'1','bynum_snum'=>'0','bynum_sprice'=>'0.00','bynum_xnum'=>'0','bynum_xprice'=>'0.00','status'=>'1','created_at'=>'1558510002','updated_at'=>'1568887029']);
        $this->insert('{{%addon_shop_express_fee}}',['id'=>'5','merchant_id'=>'1','company_id'=>'2','title'=>'哈哈','is_default'=>'0','province_ids'=>'210000,220000,230000,310000,320000,330000,340000,360000,350000,440000,450000,460000','city_ids'=>'210100,210200,210300,210400,210500,210600,210700,210800,210900,211000,211100,211200,211300,211400,220100,220200,220300,220400,220500,220600,220700,220800,222400,230100,230200,230300,230400,230500,230600,230700,230800,230900,231000,231100,231200,232700,310100,320100,320200,320300,320400,320500,320600,320700,320800,320900,321000,321100,321200,321300,330100,330200,330300,330400,330500,330600,330700,330800,330900,331000,331100,340100,340200,340300,340400,340500,340600,340700,340800,341000,341100,341200,341300,341500,341600,341700,341800,360100,360200,360300,360400,360500,360600,360700,360800,360900,361000,361100,350100,350200,350300,350400,350500,350600,350700,350800,350900,440100,440200,440300,440400,440500,440600,440700,440800,440900,441200,441300,441400,441500,441600,441700,441800,441900,442000,445100,445200,445300,450100,450200,450300,450400,450500,450600,450700,450800,450900,451000,451100,451200,451300,451400,460100,460200,460300,460400,469000','area_ids'=>'210102,210103,210104,210105,210106,210111,210112,210113,210114,210115,210123,210124,210181,210202,210203,210204,210211,210212,210213,210214,210224,210281,210283,210302,210303,210304,210311,210321,210323,210381,210402,210403,210404,210411,210421,210422,210423,210502,210503,210504,210505,210521,210522,210602,210603,210604,210624,210681,210682,210702,210703,210711,210726,210727,210781,210782,210802,210803,210804,210811,210881,210882,210902,210903,210904,210905,210911,210921,210922,211002,211003,211004,211005,211011,211021,211081,211102,211103,211104,211122,211202,211204,211221,211223,211224,211281,211282,211302,211303,211321,211322,211324,211381,211382,211402,211403,211404,211421,211422,211481,220102,220103,220104,220105,220106,220112,220113,220122,220171,220172,220173,220174,220182,220183,220202,220203,220204,220211,220221,220271,220272,220273,220281,220282,220283,220284,220302,220303,220322,220323,220381,220382,220402,220403,220421,220422,220502,220503,220521,220523,220524,220581,220582,220602,220605,220621,220622,220623,220681,220702,220721,220722,220723,220771,220781,220802,220821,220822,220871,220881,220882,222401,222402,222403,222404,222405,222406,222424,222426,230102,230103,230104,230108,230109,230110,230111,230112,230113,230123,230124,230125,230126,230127,230128,230129,230183,230184,230202,230203,230204,230205,230206,230207,230208,230221,230223,230224,230225,230227,230229,230230,230231,230281,230302,230303,230304,230305,230306,230307,230321,230381,230382,230402,230403,230404,230405,230406,230407,230421,230422,230502,230503,230505,230506,230521,230522,230523,230524,230602,230603,230604,230605,230606,230621,230622,230623,230624,230671,230702,230703,230704,230705,230706,230707,230708,230709,230710,230711,230712,230713,230714,230715,230716,230722,230781,230803,230804,230805,230811,230822,230826,230828,230881,230882,230883,230902,230903,230904,230921,231002,231003,231004,231005,231025,231071,231081,231083,231084,231085,231086,231102,231121,231123,231124,231181,231182,231202,231221,231222,231223,231224,231225,231226,231281,231282,231283,232701,232702,232703,232704,232721,232722,232723,310101,310104,310105,310106,310107,310109,310110,310112,310113,310114,310115,310116,310117,310118,310120,310151,320102,320104,320105,320106,320111,320113,320114,320115,320116,320117,320118,320205,320206,320211,320213,320214,320281,320282,320302,320303,320305,320311,320312,320321,320322,320324,320371,320381,320382,320402,320404,320411,320412,320413,320481,320505,320506,320507,320508,320509,320571,320581,320582,320583,320585,320602,320611,320612,320621,320623,320671,320681,320682,320684,320703,320706,320707,320722,320723,320724,320771,320772,320803,320804,320812,320813,320826,320830,320831,320871,320902,320903,320904,320921,320922,320923,320924,320925,320971,320981,321002,321003,321012,321023,321071,321081,321084,321102,321111,321112,321171,321181,321182,321183,321202,321203,321204,321271,321281,321282,321283,321302,321311,321322,321323,321324,321371,330102,330103,330104,330105,330106,330108,330109,330110,330111,330112,330122,330127,330182,330203,330205,330206,330211,330212,330213,330225,330226,330281,330282,330302,330303,330304,330305,330324,330326,330327,330328,330329,330371,330381,330382,330402,330411,330421,330424,330481,330482,330483,330502,330503,330521,330522,330523,330602,330603,330604,330624,330681,330683,330702,330703,330723,330726,330727,330781,330782,330783,330784,330802,330803,330822,330824,330825,330881,330902,330903,330921,330922,331002,331003,331004,331022,331023,331024,331081,331082,331083,331102,331121,331122,331123,331124,331125,331126,331127,331181,340102,340103,340104,340111,340121,340122,340123,340124,340171,340172,340173,340181,340202,340203,340207,340208,340221,340222,340223,340225,340271,340272,340302,340303,340304,340311,340321,340322,340323,340371,340372,340402,340403,340404,340405,340406,340421,340422,340503,340504,340506,340521,340522,340523,340602,340603,340604,340621,340705,340706,340711,340722,340802,340803,340811,340822,340824,340825,340826,340827,340828,340871,340881,341002,341003,341004,341021,341022,341023,341024,341102,341103,341122,341124,341125,341126,341171,341172,341181,341182,341202,341203,341204,341221,341222,341225,341226,341271,341272,341282,341302,341321,341322,341323,341324,341371,341372,341502,341503,341504,341522,341523,341524,341525,341602,341621,341622,341623,341702,341721,341722,341723,341802,341821,341822,341823,341824,341825,341871,341881,360102,360103,360104,360105,360111,360112,360121,360123,360124,360202,360203,360222,360281,360302,360313,360321,360322,360323,360402,360403,360404,360423,360424,360425,360426,360428,360429,360430,360481,360482,360483,360502,360521,360602,360622,360681,360702,360703,360704,360722,360723,360724,360725,360726,360727,360728,360729,360730,360731,360732,360733,360734,360735,360781,360802,360803,360821,360822,360823,360824,360825,360826,360827,360828,360829,360830,360881,360902,360921,360922,360923,360924,360925,360926,360981,360982,360983,361002,361003,361021,361022,361023,361024,361025,361026,361027,361028,361030,361102,361103,361121,361123,361124,361125,361126,361127,361128,361129,361130,361181,350102,350103,350104,350105,350111,350121,350122,350123,350124,350125,350128,350181,350182,350203,350205,350206,350211,350212,350213,350302,350303,350304,350305,350322,350402,350403,350421,350423,350424,350425,350426,350427,350428,350429,350430,350481,350502,350503,350504,350505,350521,350524,350525,350526,350527,350581,350582,350583,350602,350603,350622,350623,350624,350625,350626,350627,350628,350629,350681,350702,350703,350721,350722,350723,350724,350725,350781,350782,350783,350802,350803,350821,350823,350824,350825,350881,350902,350921,350922,350923,350924,350925,350926,350981,350982,440103,440104,440105,440106,440111,440112,440113,440114,440115,440117,440118,440203,440204,440205,440222,440224,440229,440232,440233,440281,440282,440303,440304,440305,440306,440307,440308,440309,440310,440402,440403,440404,440507,440511,440512,440513,440514,440515,440523,440604,440605,440606,440607,440608,440703,440704,440705,440781,440783,440784,440785,440802,440803,440804,440811,440823,440825,440881,440882,440883,440902,440904,440981,440982,440983,441202,441203,441204,441223,441224,441225,441226,441284,441302,441303,441322,441323,441324,441402,441403,441422,441423,441424,441426,441427,441481,441502,441521,441523,441581,441602,441621,441622,441623,441624,441625,441702,441704,441721,441781,441802,441803,441821,441823,441825,441826,441881,441882,441900003,441900004,441900005,441900006,441900101,441900102,441900103,441900104,441900105,441900106,441900107,441900108,441900109,441900110,441900111,441900112,441900113,441900114,441900115,441900116,441900117,441900118,441900119,441900121,441900122,441900123,441900124,441900125,441900126,441900127,441900128,441900129,441900401,441900402,441900403,442000001,442000002,442000003,442000004,442000005,442000006,442000100,442000101,442000102,442000103,442000104,442000105,442000106,442000107,442000108,442000109,442000110,442000111,442000112,442000113,442000114,442000115,442000116,442000117,445102,445103,445122,445202,445203,445222,445224,445281,445302,445303,445321,445322,445381,450102,450103,450105,450107,450108,450109,450110,450123,450124,450125,450126,450127,450202,450203,450204,450205,450206,450222,450223,450224,450225,450226,450302,450303,450304,450305,450311,450312,450321,450323,450324,450325,450326,450327,450328,450329,450330,450331,450332,450403,450405,450406,450421,450422,450423,450481,450502,450503,450512,450521,450602,450603,450621,450681,450702,450703,450721,450722,450802,450803,450804,450821,450881,450902,450903,450921,450922,450923,450924,450981,451002,451021,451022,451023,451024,451026,451027,451028,451029,451030,451031,451081,451102,451103,451121,451122,451123,451202,451203,451221,451222,451223,451224,451225,451226,451227,451228,451229,451302,451321,451322,451323,451324,451381,451402,451421,451422,451423,451424,451425,451481,460105,460106,460107,460108,460202,460203,460204,460205,460321,460322,460323,460400100,460400101,460400102,460400103,460400104,460400105,460400106,460400107,460400108,460400109,460400111,460400112,460400113,460400114,460400115,460400116,460400499,460400500,469001,469002,469005,469006,469007,469021,469022,469023,469024,469025,469026,469027,469028,469029,469030','weight_is_use'=>'1','weight_snum'=>'0.00','weight_sprice'=>'0.00','weight_xnum'=>'0.00','weight_xprice'=>'0.00','volume_is_use'=>'1','volume_snum'=>'0.00','volume_sprice'=>'0.00','volume_xnum'=>'0.00','volume_xprice'=>'0.00','bynum_is_use'=>'1','bynum_snum'=>'0','bynum_sprice'=>'0.00','bynum_xnum'=>'0','bynum_xprice'=>'0.00','status'=>'1','created_at'=>'1558510020','updated_at'=>'1558510020']);
        $this->insert('{{%addon_shop_express_fee}}',['id'=>'6','merchant_id'=>'1','company_id'=>'2','title'=>'1123','is_default'=>'0','province_ids'=>'120000,130000,140000,150000,370000','city_ids'=>'120100,130100,130200,130300,130400,130500,130600,130700,130800,130900,131000,131100,140100,140200,140300,140400,140500,140600,140700,140800,140900,141000,141100,150100,150200,150300,150400,150500,150600,150700,150800,150900,152200,152500,152900,370100,370200,370300,370400,370500,370600,370700,370800,370900,371000,371100,371200,371300,371400,371500,371600,371700','area_ids'=>'120101,120102,120103,120104,120105,120106,120110,120111,120112,120113,120114,120115,120116,120117,120118,120119,130102,130104,130105,130107,130108,130109,130110,130111,130121,130123,130125,130126,130127,130128,130129,130130,130131,130132,130133,130171,130172,130181,130183,130184,130202,130203,130204,130205,130207,130208,130209,130223,130224,130225,130227,130229,130271,130272,130273,130274,130281,130283,130302,130303,130304,130306,130321,130322,130324,130371,130372,130402,130403,130404,130406,130407,130408,130423,130424,130425,130426,130427,130430,130431,130432,130433,130434,130435,130471,130473,130481,130502,130503,130521,130522,130523,130524,130525,130526,130527,130528,130529,130530,130531,130532,130533,130534,130535,130571,130581,130582,130602,130606,130607,130608,130609,130623,130624,130626,130627,130628,130629,130630,130631,130632,130633,130634,130635,130636,130637,130638,130671,130672,130681,130682,130683,130684,130702,130703,130705,130706,130708,130709,130722,130723,130724,130725,130726,130727,130728,130730,130731,130732,130771,130772,130773,130802,130803,130804,130821,130822,130824,130825,130826,130827,130828,130871,130881,130902,130903,130921,130922,130923,130924,130925,130926,130927,130928,130929,130930,130971,130972,130973,130981,130982,130983,130984,131002,131003,131022,131023,131024,131025,131026,131028,131071,131081,131082,131102,131103,131121,131122,131123,131124,131125,131126,131127,131128,131171,131172,131182,140105,140106,140107,140108,140109,140110,140121,140122,140123,140171,140181,140202,140203,140211,140212,140221,140222,140223,140224,140225,140226,140227,140271,140302,140303,140311,140321,140322,140371,140402,140411,140421,140423,140424,140425,140426,140427,140428,140429,140430,140431,140471,140481,140502,140521,140522,140524,140525,140581,140602,140603,140621,140622,140623,140624,140671,140702,140721,140722,140723,140724,140725,140726,140727,140728,140729,140781,140802,140821,140822,140823,140824,140825,140826,140827,140828,140829,140830,140881,140882,140902,140921,140922,140923,140924,140925,140926,140927,140928,140929,140930,140931,140932,140971,140981,141002,141021,141022,141023,141024,141025,141026,141027,141028,141029,141030,141031,141032,141033,141034,141081,141082,141102,141121,141122,141123,141124,141125,141126,141127,141128,141129,141130,141181,141182,150102,150103,150104,150105,150121,150122,150123,150124,150125,150171,150172,150202,150203,150204,150205,150206,150207,150221,150222,150223,150271,150302,150303,150304,150402,150403,150404,150421,150422,150423,150424,150425,150426,150428,150429,150430,150502,150521,150522,150523,150524,150525,150526,150571,150581,150602,150603,150621,150622,150623,150624,150625,150626,150627,150702,150703,150721,150722,150723,150724,150725,150726,150727,150781,150782,150783,150784,150785,150802,150821,150822,150823,150824,150825,150826,150902,150921,150922,150923,150924,150925,150926,150927,150928,150929,150981,152201,152202,152221,152222,152223,152224,152501,152502,152522,152523,152524,152525,152526,152527,152528,152529,152530,152531,152571,152921,152922,152923,152971,370102,370103,370104,370105,370112,370113,370114,370124,370125,370126,370171,370202,370203,370211,370212,370213,370214,370215,370271,370281,370283,370285,370302,370303,370304,370305,370306,370321,370322,370323,370402,370403,370404,370405,370406,370481,370502,370503,370505,370522,370523,370571,370572,370602,370611,370612,370613,370634,370671,370672,370681,370682,370683,370684,370685,370686,370687,370702,370703,370704,370705,370724,370725,370772,370781,370782,370783,370784,370785,370786,370811,370812,370826,370827,370828,370829,370830,370831,370832,370871,370881,370883,370902,370911,370921,370923,370982,370983,371002,371003,371071,371072,371073,371082,371083,371102,371103,371121,371122,371171,371172,371202,371203,371302,371311,371312,371321,371322,371323,371324,371325,371326,371327,371328,371329,371371,371372,371373,371402,371403,371422,371423,371424,371425,371426,371427,371428,371471,371472,371481,371482,371502,371521,371522,371523,371524,371525,371526,371581,371602,371603,371621,371622,371623,371625,371626,371702,371703,371721,371722,371723,371724,371725,371726,371728,371771,371772','weight_is_use'=>'1','weight_snum'=>'0.00','weight_sprice'=>'0.00','weight_xnum'=>'0.00','weight_xprice'=>'0.00','volume_is_use'=>'1','volume_snum'=>'0.00','volume_sprice'=>'0.00','volume_xnum'=>'0.00','volume_xprice'=>'0.00','bynum_is_use'=>'1','bynum_snum'=>'0','bynum_sprice'=>'0.00','bynum_xnum'=>'0','bynum_xprice'=>'0.00','status'=>'1','created_at'=>'1558660184','updated_at'=>'1558660184']);
        
        /* 设置外键约束 */
        $this->execute('SET foreign_key_checks = 1;');
    }

    public function down()
    {
        $this->execute('SET foreign_key_checks = 0');
        /* 删除表 */
        $this->dropTable('{{%addon_shop_express_fee}}');
        $this->execute('SET foreign_key_checks = 1;');
    }
}

